﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$" formatter="bizobj of CompanySettings">
	<Sql>
		SELECT
		<code>
			IBizObjList fields = App.ruleMgr.execute("getCompanySettingsDbFields").CallResults as IBizObjList;
			if(fields != null)
				foreach(IBizObj field in fields)
					sql.AppendFormat("{0} as {1},", field.get("dbName"), field.get("aliasName"));
		</code>
		companyId as id
		FROM CompanyBasicSettings
		WHERE companyId=@id
	</Sql>
	
	<Param name="id" type="UniqueIdentifier"/>
</AdoNetDataAccess>
